SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE dbo.DnnProduct_SR_SQL_AddConnection
(
	@Name nvarchar(50),
	@ConnectionString nvarchar(255),
	@ModuleID int
)
AS
BEGIN
	INSERT INTO dbo.DnnProduct_SR_SQL_Connections
	(Name, ConnectionString, ModuleID)
	VALUES
	(@Name, @ConnectionString, @ModuleID)
	
	--Return the newly generated id
	SELECT @@IDENTITY as ConnectionID
END

GO
